AR Sales Tax
The AR Sales Tax report reviews sales tax amounts by client and sales tax authority. This report includes the sales tax amounts and sales tax authority associated with billing, AR transactions, or both.
Permissions Required for this Report
In the staff profile, staff must be assigned to a security group that is granted View functional rights for the following:
- Security group profile > Functional rights > Reports > Shared Library > Shared Views
- Security group profile > Functional rights > Reports > Firm Library > Custom
- Security group profile > Functional rights > Reports > Firm Library > Standard > Firm
- Security group profile > Functional rights > Reports > Firm Library > Standard > Practice
- Security group profile > Functional rights > Reports > Firm Library > <report name>
- Security group profile > Functional rights > Administration Manager > Client Manager > Approved Clients
Reports in Foundation that are Comparable
In Practice Management and Practice Advantage, there are no comparable reports. This is a new standard report.
Report Specifications
The following report options and filters are available to determine the report contents.
Options and Settings | ||
---|---|---|
Option | Setting | Description |
Hide Details |
Yes/No |
Includes or excludes details of each transaction. If excluded, only the headers and footers for each group with amounts only for the grand total display in the report. To view a summary amount for each group, select to subtotal the group. |
Hide Penny |
Yes/No |
Includes or excludes pennies in amounts. |
Hide Comma |
Yes/No |
Includes or excludes commas in numbers. |
Include Deleted Clients |
Yes/No |
Includes or excludes deleted client information. |
Default Filters | ||
---|---|---|
Field Name | Operator | Value |
Transaction Date |
Between |
First Day of Current Fiscal Year, Last Day of Current Fiscal Year |
Transaction Type |
= |
All |
Transaction Status |
= |
Posted |
Optional Filters | ||
---|---|---|
Available Fields | ||
Accounting Period Date |
Client Office |
Primary Partner |
Applied To |
Client Primary Service Type |
Return Group |
Business Code |
Client Region |
Sales Tax |
Client |
Client Sub ID |
Tax Authority |
Client – Principal |
Client Type |
Tax Type |
Client Bill Manager |
Document # |
Transaction Date |
Client Business Unit |
Financial Reporting Client Group |
Transaction Status |
Client ID |
Line of Business |
Transaction Type |
Client ID.Sub ID |
Manager |
|
Client Name |
Posted Date |
|
Grouping | ||
---|---|---|
Available Fields | ||
Business Code |
Client Name |
Line of Business |
Client |
Client Office |
Manager |
Client – Principal |
Client Primary Service Type |
Primary Partner |
Client Bill Manager |
Client Region |
Sort Name |
Client Business Unit |
Client Sub ID |
Tax Authority |
Client ID |
Client Type |
|
Client ID.Sub ID |
Financial Reporting Client Group |
|
Sorting | ||
---|---|---|
Available Fields | ||
Accounting Period Date |
Document # |
Transaction Date |
Applied To |
Sales Tax |
Transaction Status |
Client |
Tax Authority |
Transaction Type |
Report Fields
The following fields are available for this report. The fields that display and the position of fields are based on the report's settings, grouping, sorting, and filters.
Report Fields | |
---|---|
Field | Description |
Transaction Date |
The date the transaction was entered. |
Accounting Period Date |
The date of the accounting period to which the transaction was entered. |
Type |
The transaction type. The options include Invoice, Payment, Credit Memo, Credit Adjustment, GST Write-off, Write-off, Debit Memo, Debit Adjustment, Miscellaneous Charge, Handling Fee, and Finance Charge. |
Document # |
The invoice or the reference number of the AR transaction. |
Applied To |
Typically, the invoice number of the transaction. |
Status |
The transaction status. The options are Posted and Unposted. |
Sales Tax |
The sales tax amount. The report displays sales tax from invoice and debits as positive and displays sales tax applied amounts from payment and credits as negative. |
Tax Authority |
The sales tax authority of the transaction. |
AR Sales Tax Sample Report